home *** CD-ROM | disk | FTP | other *** search
/ Programming Microsoft Visual Basic .NET / Programming Microsoft Visual Basic .NET (Microsoft Press)(X08-78517)(2002).bin / 22 xml and adonet / xmldemo / dsbiblio.xsd < prev    next >
Extensible Markup Language  |  2001-12-23  |  3KB  |  53 lines
  1. <?xml version="1.0" standalone="yes" ?>
  2. <xs:schema id="dsBiblio" targetNamespace="http://www.tempuri.org/dsBiblio.xsd" xmlns:mstns="http://www.tempuri.org/dsBiblio.xsd" xmlns="http://www.tempuri.org/dsBiblio.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
  3.     <xs:element name="dsBiblio" msdata:IsDataSet="true">
  4.         <xs:complexType>
  5.             <xs:choice maxOccurs="unbounded">
  6.                 <xs:element name="Publishers">
  7.                     <xs:complexType>
  8.                         <xs:sequence>
  9.                             <xs:element name="PubID" msdata:AutoIncrement="true" type="xs:int" />
  10.                             <xs:element name="Name" type="xs:string" minOccurs="0" />
  11.                             <xs:element name="Company_x0020_Name" type="xs:string" minOccurs="0" />
  12.                             <xs:element name="Address" type="xs:string" minOccurs="0" />
  13.                             <xs:element name="City" type="xs:string" minOccurs="0" />
  14.                             <xs:element name="Zip" type="xs:string" minOccurs="0" />
  15.                             <xs:element name="State" type="xs:string" minOccurs="0" />
  16.                             <xs:element name="Telephone" type="xs:string" minOccurs="0" />
  17.                             <xs:element name="Fax" type="xs:string" minOccurs="0" />
  18.                             <xs:element name="Comments" type="xs:string" minOccurs="0" />
  19.                         </xs:sequence>
  20.                     </xs:complexType>
  21.                 </xs:element>
  22.                 <xs:element name="Titles">
  23.                     <xs:complexType>
  24.                         <xs:sequence>
  25.                             <xs:element name="Title" type="xs:string" minOccurs="0" />
  26.                             <xs:element name="ISBN" type="xs:string" />
  27.                             <xs:element name="Year_x0020_Published" type="xs:short" minOccurs="0" />
  28.                             <xs:element name="PubID" type="xs:int" minOccurs="0" />
  29.                             <xs:element name="Subject" type="xs:string" minOccurs="0" />
  30.                             <xs:element name="Comments" type="xs:string" minOccurs="0" />
  31.                             <xs:element name="Description" type="xs:string" minOccurs="0" />
  32.                             <xs:element name="Notes" type="xs:string" minOccurs="0" />
  33.                             <xs:element name="Price" type="xs:float" minOccurs="0" />
  34.                             <xs:element name="DiscountedPrice" type="xs:float" minOccurs="0" msdata:Expression="Price * .8" />
  35.                         </xs:sequence>
  36.                     </xs:complexType>
  37.                 </xs:element>
  38.             </xs:choice>
  39.         </xs:complexType>
  40.         <xs:unique name="Constraint1" msdata:PrimaryKey="true">
  41.             <xs:selector xpath=".//mstns:Publishers" />
  42.             <xs:field xpath="mstns:PubID" />
  43.         </xs:unique>
  44.         <xs:unique name="Titles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  45.             <xs:selector xpath=".//mstns:Titles" />
  46.             <xs:field xpath="mstns:ISBN" />
  47.         </xs:unique>
  48.         <xs:keyref name="PublishersTitles" refer="mstns:Constraint1" msdata:UpdateRule="Cascade">
  49.             <xs:selector xpath=".//mstns:Titles" />
  50.             <xs:field xpath="mstns:PubID" />
  51.         </xs:keyref>
  52.     </xs:element>
  53. </xs:schema>